package db;


/**
 * <p>Title: 存放所有SQL语句</p>
 * <p>Description: </p>
 * @author zhangzuoqiang
 * <br/>Date: 2011-3-8
 */
public final class SQLangs {
		
	/**
	 * 删除一个用户
	 * @param id
	 * @return
	 */
	public static String deleteDataVO(int id){
		return "delete from lang where id = '" + id + "';";
	}
	
	/**
	 * 新添加一个用户
	 * @param vo
	 * @return
	 */
	public static String addDataVO(DataVO vo){
		return "insert into lang(id, name, age, isgraduate) values ('" + vo.getId() + "','" + vo.getName() 
					+ "','" + vo.getAge() + "','" + vo.getIsgraduate() + "');";
	}
	
	/**
	 *  根据age查询用户列表
	 * @param age
	 * @return
	 */
	public static String selectDataVOsByAge(int age){
		return "select id, name, age, isgraduate from lang where age = '" + age + "';";
	}
}
